From the following table , I want to build a query using analytical functions to retrieve the rows where there is a common document type for a Customer ID but not the mix. The output should be only ROW_NO 3,4,5 & 9,10 CREATE TABLE TAB_DOC_TYPES (ROW_NO NUMBER, CID NUMBER, DOC_TYP...

I need function which convert numeric to alphabet like when I input 1 then it will return 'A', when i input 2 then it will return 'B' please help me on this.

How can I convince my developers there is a better way to do this? SELECT MAX (weight) weight FROM client.pet_weight WHERE pet_id = :pet_id AND setup_date = (SELECT MAX (setup_date) FROM client.pet_w

Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc: create table doc_ind ( doc_id integer, ind_code varchar2(10) ) This table will therefore als

Some Days before I have Install Oracle Database New version 12.1.0.2 with no error or warnings. Created 2 pluggable databases in the DB container. SELECT name, open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED